package com.iflytek.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.iflytek.vo.StockInOrderVO;
import com.iflytek.vo.StockOutOrderVO;

public interface SooApproveMapper {
	
	
	@Select("SELECT * FROM stock_out_order s join goods g on s.goods_id=g.goods_id "
			+ "join warehouse w on s.soo_warehouse_id=w.warehouse_id ")
	List<StockOutOrderVO> selectByExample();
	
	@Select("SELECT * FROM stock_out_order s join goods g on s.goods_id=g.goods_id "
			+ "join warehouse w on s.soo_warehouse_id=w.warehouse_id where s.status=1")
	List<StockOutOrderVO> selectByStatus1();

	@Update("update stock_out_order set status=1 where order_id=#{id}")
	void updateApproveStatus(Integer id);
	
	@Select("SELECT * FROM stock_out_order WHERE order_id=#{id}")
	StockOutOrderVO selectOrderById(Integer id);
	
	
	



}
